package cn.gson.fengboot.model.dao;

import cn.gson.fengboot.model.pojos.Lrizhi;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface LrizhiDao extends CrudRepository<Lrizhi,Integer> {

    //圆形统计图日志类型分布查询
    @Query(nativeQuery = true,value = "select count(*) from lrizhi where  rz_lx=?1 ")
    public Integer rzlxcs(String Type);

    //圆形统计图员工数量查询
    @Query(nativeQuery = true,value = "SELECT count(*) FROM lrizhi e LEFT JOIN qemp_from d  on e.emp_id= d.emp_id WHERE d.emp_name =?1 ")
    public Integer rzygcs(String Type);
}
